﻿CREATE TABLE [dbo].[App_Roles] (
    [ID]          INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Mid]         VARCHAR (MAX)  CONSTRAINT [DF_App_Roles_Mid] DEFAULT ('') NULL,
    [Cid]         VARCHAR (MAX)  CONSTRAINT [DF_App_Roles_Cid] DEFAULT ('') NULL,
    [Did]         VARCHAR (MAX)  CONSTRAINT [DF_App_Roles_Did] DEFAULT ('') NULL,
    [RName]       NVARCHAR (20)  CONSTRAINT [DF_App_Roles_RName] DEFAULT ('') NULL,
    [EntryPeople] NVARCHAR (20)  CONSTRAINT [DF_App_Roles_EntryPeople] DEFAULT ('') NULL,
    [EntryTime]   DATETIME       CONSTRAINT [DF_App_Roles_EntryTime] DEFAULT (getdate()) NULL,
    [RNote]       NVARCHAR (MAX) CONSTRAINT [DF_App_Roles_RNote] DEFAULT ('') NULL,
    [FAdminFlg]   BIT            CONSTRAINT [DF_App_Roles_FAdminFlg] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_App_Roles] PRIMARY KEY CLUSTERED ([ID] ASC)
);

